CREATE TABLE [dbo].[wad_programas]
(
[nm_programa] [dbo].[_codigo_largo] NOT NULL,
[de_programa] [dbo].[_descripcion] NOT NULL,
[nm_subsistema] [dbo].[_nombre] NOT NULL,
[tp_programa] [dbo].[_lista] NOT NULL,
[nm_clase] [dbo].[_descripcion] NOT NULL,
[de_ayuda] [dbo].[_memo] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wad_programas] ADD CONSTRAINT [PK_wad_programas] PRIMARY KEY CLUSTERED  ([nm_programa]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [FK_nm_subsistema] ON [dbo].[wad_programas] ([nm_subsistema]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wad_programas] ADD CONSTRAINT [FK_wad_programas_wap_subsistemas] FOREIGN KEY ([nm_subsistema]) REFERENCES [dbo].[wap_subsistemas] ([nm_subsistema])
GO
